[overshoot] the mark

to make a mistake, particularly in judging the amount of something

The idiom "overshoot the mark" originated from archery, where the "mark" refers to the target that the archer aims for. When an archer shoots an arrow and it goes beyond the mark, they have overshot the mark. It can be used to describe a range of scenarios where someone has overreached, overestimated, or over-committed themselves, resulting in a negative outcome or consequence.

I overshot the mark and added too much salt to the recipe.
The contractor overshot the mark and ordered too much lumber for the project.

to go further past the place where one intended to be

The origin of the idiom "overshoot the mark" lies in archery, where the "mark" refers to the target. When an archer pulls back the bowstring and releases the arrow, there is a risk of exerting too much force, causing the arrow to fly past the intended target. The expression is mostly used metaphorically to signify going beyond or surpassing the intended goal or stopping point.

The speaker's attempt to engage the audience backfired when they overshoot the mark and ended up offending some listeners.
The company overshot the mark with its ambitious sales projections, leading to unrealistic expectations and disappointing results.
The comedian's joke was meant to be lighthearted, but he overshoot the mark and crossed into offensive territory.
The chef's enthusiasm got the better of him, causing him to overshoot the mark and add too much spice to the dish.
The team's aggressive playing style occasionally led them to overshoot the mark, resulting in unnecessary fouls and penalties.